45 : <cfreturn Replace(lcase(trim(Replace(ReplaceList(arguments.str," ,/,.","-,|,_"),"&","","ALL"))),"---","-","ALL") />
46 : </cffunction>
47 : <cfquery name="getcumtaxonomy" datasource="#application.ds#">
48 : select ecomm_taxonomy_id * 10000 as master_taxonomy_id, dept, case when typ = '' then 'EMPTY' else typ end as typ, case when subtyp = '' then 'EMPTY' else subtyp end as subtyp_1,
49 : case when web_url = '' or web_url like '% %' then 'INVALID_URL' else web_url end as web_url
|